From 7fc2f2936e959d260358ec99729bf5d541f8bd01 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 5 Aug 2026 17:09:50 +0000 Subject: [PATCH] Move comm_memb_log from sokwedb schema to housekeeping --- conversion/load_community_membership_update_log.sql | 4 ++-- db/schemas/housekeeping/indexes/Makefile | 1 + .../{sokwedb => housekeeping}/indexes/create/comm_memb_log.m4 | 0 .../{sokwedb => housekeeping}/indexes/drop/comm_memb_log.m4 | 0 db/schemas/housekeeping/tables/Makefile | 1 + .../{sokwedb => housekeeping}/tables/create/comm_memb_log.m4 | 0 db/schemas/sokwedb/indexes/Makefile | 2 +- db/schemas/sokwedb/tables/Makefile | 1 - doc/src/housekeeping.m4 | 1 + doc/src/{tables => housekeeping}/comm_memb_log.m4 | 0 doc/src/tables.m4 | 1 - 11 files changed, 6 insertions(+), 5 deletions(-) rename db/schemas/{sokwedb => housekeeping}/indexes/create/comm_memb_log.m4 (100%) rename db/schemas/{sokwedb => housekeeping}/indexes/drop/comm_memb_log.m4 (100%) rename db/schemas/{sokwedb => housekeeping}/tables/create/comm_memb_log.m4 (100%) rename doc/src/{tables => housekeeping}/comm_memb_log.m4 (100%) diff --git a/conversion/load_community_membership_update_log.sql b/conversion/load_community_membership_update_log.sql index 633aea2..a1ad076 100644 --- a/conversion/load_community_membership_update_log.sql +++ b/conversion/load_community_membership_update_log.sql @@ -1,4 +1,4 @@ --- Copyright (C) 2023, 2024, 2025 The Meme Factory, Inc. +-- Copyright (C) 2023, 2024, 2025, 2026 The Meme Factory, Inc. -- http://www.karlpinc.com/ -- -- This program is free software: you can redistribute it and/or modify @@ -17,7 +17,7 @@ -- Karl O. Pinc -- Setup the search path -SET search_path TO sokwedb, codes, lib, clean, libconv; +SET search_path TO sokwedb, housekeeping, codes, lib, clean, libconv; diff --git a/db/schemas/housekeeping/indexes/Makefile b/db/schemas/housekeeping/indexes/Makefile index d23e913..1159e5c 100644 --- a/db/schemas/housekeeping/indexes/Makefile +++ b/db/schemas/housekeeping/indexes/Makefile @@ -23,6 +23,7 @@ ORDER := aggression_event_log \ biography_log \ chimps_on_tikis \ community_membership_update_log \ + comm_memb_log \ food_variations \ pantgrunt_event_log \ siv_status_bout \ diff --git a/db/schemas/sokwedb/indexes/create/comm_memb_log.m4 b/db/schemas/housekeeping/indexes/create/comm_memb_log.m4 similarity index 100% rename from db/schemas/sokwedb/indexes/create/comm_memb_log.m4 rename to db/schemas/housekeeping/indexes/create/comm_memb_log.m4 diff --git a/db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 b/db/schemas/housekeeping/indexes/drop/comm_memb_log.m4 similarity index 100% rename from db/schemas/sokwedb/indexes/drop/comm_memb_log.m4 rename to db/schemas/housekeeping/indexes/drop/comm_memb_log.m4 diff --git a/db/schemas/housekeeping/tables/Makefile b/db/schemas/housekeeping/tables/Makefile index fc76f2c..801edaf 100644 --- a/db/schemas/housekeeping/tables/Makefile +++ b/db/schemas/housekeeping/tables/Makefile @@ -23,6 +23,7 @@ ORDER := aggression_event_log \ biography_log \ chimps_on_tikis \ + comm_memb_log \ community_membership_update_log \ food_variations \ pantgrunt_event_log \ diff --git a/db/schemas/sokwedb/tables/create/comm_memb_log.m4 b/db/schemas/housekeeping/tables/create/comm_memb_log.m4 similarity index 100% rename from db/schemas/sokwedb/tables/create/comm_memb_log.m4 rename to db/schemas/housekeeping/tables/create/comm_memb_log.m4 diff --git a/db/schemas/sokwedb/indexes/Makefile b/db/schemas/sokwedb/indexes/Makefile index 45acdec..df5a2cc 100644 --- a/db/schemas/sokwedb/indexes/Makefile +++ b/db/schemas/sokwedb/indexes/Makefile @@ -19,7 +19,7 @@ # This determines the order in which the indexes are put into the database. # This is not really important but is needed for other types of db objects. -ORDER := biography_data comm_membs comm_memb_log \ +ORDER := biography_data comm_membs \ watches follow_observers follow_studies events roles arrivals \ swelling_sources swelling_states sightings \ aggressions food_events groomings \ diff --git a/db/schemas/sokwedb/tables/Makefile b/db/schemas/sokwedb/tables/Makefile index 24e6714..0780341 100644 --- a/db/schemas/sokwedb/tables/Makefile +++ b/db/schemas/sokwedb/tables/Makefile @@ -24,7 +24,6 @@ ORDER := biography_data \ swelling_sources \ swelling_states \ comm_membs \ - comm_memb_log \ sightings \ watches \ follow_observers \ diff --git a/doc/src/housekeeping.m4 b/doc/src/housekeeping.m4 index 94bf888..86d9147 100644 --- a/doc/src/housekeeping.m4 +++ b/doc/src/housekeeping.m4 @@ -36,6 +36,7 @@ The tables in this section are all in the ``housekeeping`` schema. housekeeping/aggression_event_log.rst housekeeping/biography_log.rst housekeeping/chimps_on_tikis.rst + housekeeping/comm_memb_log.rst housekeeping/food_variations.rst housekeeping/community_membership_update_log.rst housekeeping/pantgrunt_event_log.rst diff --git a/doc/src/tables/comm_memb_log.m4 b/doc/src/housekeeping/comm_memb_log.m4 similarity index 100% rename from doc/src/tables/comm_memb_log.m4 rename to doc/src/housekeeping/comm_memb_log.m4 diff --git a/doc/src/tables.m4 b/doc/src/tables.m4 index 6d17415..7f2efb9 100644 --- a/doc/src/tables.m4 +++ b/doc/src/tables.m4 @@ -39,7 +39,6 @@ and are therefore the result of at least a rudimentary analytical process. tables/brecord_notes.rst tables/colobus.rst tables/comm_membs.rst - tables/comm_memb_log.rst tables/events.rst tables/follow_observers.rst tables/follow_studies.rst -- 2.34.1